Trips Data Report

Brought to you by YData

Dataset statistics

Number of variables	16
Number of observations	200000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	126.2 MiB
Average record size in memory	661.9 B

Variable types

Text	3
Numeric	7
Categorical	4
DateTime	2

Alerts

`city` is highly overall correlated with `dropoff_lat` and 3 other fields	High correlation
`dropoff_lat` is highly overall correlated with `city` and 1 other fields	High correlation
`dropoff_lng` is highly overall correlated with `city` and 1 other fields	High correlation
`pickup_lat` is highly overall correlated with `city` and 1 other fields	High correlation
`pickup_lng` is highly overall correlated with `city` and 1 other fields	High correlation
`trip_id` has unique values	Unique
`tip` has 131307 (65.7%) zeros	Zeros

Reproduction

Analysis started	2025-05-20 18:54:42.519358
Analysis finished	2025-05-20 18:56:34.250888
Duration	1 minute and 51.73 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

trip_id
Text

Unique

Distinct	200000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	12.2 MiB

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	1400000
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	200000 ?
Unique (%)	100.0%

Sample

1st row	T000000
2nd row	T000001
3rd row	T000002
4th row	T000003
5th row	T000004

Value	Count	Frequency (%)
t199984	1	< 0.1%
t199985	1	< 0.1%
t199986	1	< 0.1%
t199987	1	< 0.1%
t199988	1	< 0.1%
t199989	1	< 0.1%
t199990	1	< 0.1%
t199991	1	< 0.1%
t199992	1	< 0.1%
t199993	1	< 0.1%
Other values (199990)	199990	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
T	200000	14.3%
1	200000	14.3%
0	200000	14.3%
9	100000	7.1%
8	100000	7.1%
3	100000	7.1%
2	100000	7.1%
7	100000	7.1%
6	100000	7.1%
5	100000	7.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1400000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
T	200000	14.3%
1	200000	14.3%
0	200000	14.3%
9	100000	7.1%
8	100000	7.1%
3	100000	7.1%
2	100000	7.1%
7	100000	7.1%
6	100000	7.1%
5	100000	7.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1400000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
T	200000	14.3%
1	200000	14.3%
0	200000	14.3%
9	100000	7.1%
8	100000	7.1%
3	100000	7.1%
2	100000	7.1%
7	100000	7.1%
6	100000	7.1%
5	100000	7.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1400000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
T	200000	14.3%
1	200000	14.3%
0	200000	14.3%
9	100000	7.1%
8	100000	7.1%
3	100000	7.1%
2	100000	7.1%
7	100000	7.1%
6	100000	7.1%
5	100000	7.1%

user_id
Text

Distinct	10000
Distinct (%)	5.0%
Missing	0
Missing (%)	0.0%
Memory size	12.0 MiB

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	1200000
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	R05207
2nd row	R09453
3rd row	R00567
4th row	R09573
5th row	R03446

Value	Count	Frequency (%)
r08152	42	< 0.1%
r06728	39	< 0.1%
r09210	38	< 0.1%
r09908	37	< 0.1%
r09293	37	< 0.1%
r00739	37	< 0.1%
r04200	37	< 0.1%
r08475	36	< 0.1%
r03890	36	< 0.1%
r04109	36	< 0.1%
Other values (9990)	199625	99.8%

Most occurring characters

Value	Count	Frequency (%)
0	279765	23.3%
R	200000	16.7%
5	80402	6.7%
9	80315	6.7%
3	80247	6.7%
1	80241	6.7%
6	80119	6.7%
4	79999	6.7%
2	79923	6.7%
8	79573	6.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1200000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	279765	23.3%
R	200000	16.7%
5	80402	6.7%
9	80315	6.7%
3	80247	6.7%
1	80241	6.7%
6	80119	6.7%
4	79999	6.7%
2	79923	6.7%
8	79573	6.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1200000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	279765	23.3%
R	200000	16.7%
5	80402	6.7%
9	80315	6.7%
3	80247	6.7%
1	80241	6.7%
6	80119	6.7%
4	79999	6.7%
2	79923	6.7%
8	79573	6.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1200000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	279765	23.3%
R	200000	16.7%
5	80402	6.7%
9	80315	6.7%
3	80247	6.7%
1	80241	6.7%
6	80119	6.7%
4	79999	6.7%
2	79923	6.7%
8	79573	6.6%

driver_id
Text

Distinct	5000
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Memory size	12.0 MiB

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	1200000
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	D00315
2nd row	D03717
3rd row	D02035
4th row	D02657
5th row	D01026

Value	Count	Frequency (%)
d03093	67	< 0.1%
d01999	66	< 0.1%
d01107	65	< 0.1%
d02137	65	< 0.1%
d00627	63	< 0.1%
d02429	63	< 0.1%
d04284	63	< 0.1%
d03342	62	< 0.1%
d03541	62	< 0.1%
d03941	62	< 0.1%
Other values (4990)	199362	99.7%

Most occurring characters

Value	Count	Frequency (%)
0	299890	25.0%
D	200000	16.7%
3	100468	8.4%
1	100210	8.4%
2	99888	8.3%
4	99775	8.3%
8	60158	5.0%
5	60100	5.0%
6	59973	5.0%
9	59845	5.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1200000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	299890	25.0%
D	200000	16.7%
3	100468	8.4%
1	100210	8.4%
2	99888	8.3%
4	99775	8.3%
8	60158	5.0%
5	60100	5.0%
6	59973	5.0%
9	59845	5.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1200000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	299890	25.0%
D	200000	16.7%
3	100468	8.4%
1	100210	8.4%
2	99888	8.3%
4	99775	8.3%
8	60158	5.0%
5	60100	5.0%
6	59973	5.0%
9	59845	5.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1200000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	299890	25.0%
D	200000	16.7%
3	100468	8.4%
1	100210	8.4%
2	99888	8.3%
4	99775	8.3%
8	60158	5.0%
5	60100	5.0%
6	59973	5.0%
9	59845	5.0%

fare
Real number (ℝ)

Distinct	4224
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.401285

Minimum	2.97
Maximum	82.74
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	2.97
5-th percentile	8.12
Q1	11
median	14.13
Q3	18.35
95-th percentile	26.9905
Maximum	82.74
Range	79.77
Interquartile range (IQR)	7.35

Descriptive statistics

Standard deviation	6.163199
Coefficient of variation (CV)	0.40017435
Kurtosis	3.993813
Mean	15.401285
Median Absolute Deviation (MAD)	3.53
Skewness	1.5093314
Sum	3080256.9
Variance	37.985022
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10.97	196	0.1%
12.23	195	0.1%
12.48	194	0.1%
11.64	193	0.1%
11.03	193	0.1%
13.04	193	0.1%
13.42	193	0.1%
11.91	192	0.1%
11.3	191	0.1%
11.1	191	0.1%
Other values (4214)	198069	99.0%

Value	Count	Frequency (%)
2.97	1	< 0.1%
3.5	1	< 0.1%
3.6	1	< 0.1%
3.74	1	< 0.1%
3.79	1	< 0.1%
3.83	1	< 0.1%
3.86	1	< 0.1%
3.89	1	< 0.1%
3.93	1	< 0.1%
3.95	1	< 0.1%

Value	Count	Frequency (%)
82.74	1	< 0.1%
74.54	1	< 0.1%
72.64	1	< 0.1%
72.09	1	< 0.1%
71.32	1	< 0.1%
71.26	1	< 0.1%
70.28	1	< 0.1%
70.16	1	< 0.1%
69.15	1	< 0.1%
69.11	1	< 0.1%

surge_multiplier
Real number (ℝ)

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.1414995

Minimum	1
Maximum	3.8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1.2
95-th percentile	1.7
Maximum	3.8
Range	2.8
Interquartile range (IQR)	0.2

Descriptive statistics

Standard deviation	0.25536164
Coefficient of variation (CV)	0.22370719
Kurtosis	5.1322426
Mean	1.1414995
Median Absolute Deviation (MAD)	0
Skewness	2.1464485
Sum	228299.9
Variance	0.065209568
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
1	132853	66.4%
1.2	10901	5.5%
1.3	10599	5.3%
1.1	10322	5.2%
1.4	9588	4.8%
1.5	7714	3.9%
1.6	5856	2.9%
1.7	4165	2.1%
1.8	2865	1.4%
1.9	1868	0.9%
Other values (17)	3269	1.6%

Value	Count	Frequency (%)
1	132853	66.4%
1.1	10322	5.2%
1.2	10901	5.5%
1.3	10599	5.3%
1.4	9588	4.8%
1.5	7714	3.9%
1.6	5856	2.9%
1.7	4165	2.1%
1.8	2865	1.4%
1.9	1868	0.9%

Value	Count	Frequency (%)
3.8	1	< 0.1%
3.6	2	< 0.1%
3.5	2	< 0.1%
3.3	4	< 0.1%
3.2	3	< 0.1%
3.1	10	< 0.1%
3	11	< 0.1%
2.9	18	< 0.1%
2.8	21	< 0.1%
2.7	39	< 0.1%

tip
Real number (ℝ)

Zeros

Distinct	1088
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.4695659

Minimum	0
Maximum	21.86
Zeros	131307
Zeros (%)	65.7%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.4
95-th percentile	2.61
Maximum	21.86
Range	21.86
Interquartile range (IQR)	0.4

Descriptive statistics

Standard deviation	1.100545
Coefficient of variation (CV)	2.3437499
Kurtosis	26.593001
Mean	0.4695659
Median Absolute Deviation (MAD)	0
Skewness	4.1558573
Sum	93913.18
Variance	1.2111994
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	131307	65.7%
0.03	600	0.3%
0.01	586	0.3%
0.04	563	0.3%
0.07	550	0.3%
0.05	540	0.3%
0.08	536	0.3%
0.06	536	0.3%
0.02	519	0.3%
0.12	515	0.3%
Other values (1078)	63748	31.9%

Value	Count	Frequency (%)
0	131307	65.7%
0.01	586	0.3%
0.02	519	0.3%
0.03	600	0.3%
0.04	563	0.3%
0.05	540	0.3%
0.06	536	0.3%
0.07	550	0.3%
0.08	536	0.3%
0.09	483	0.2%

Value	Count	Frequency (%)
21.86	1	< 0.1%
19.13	1	< 0.1%
18.45	1	< 0.1%
17.94	2	< 0.1%
17.74	1	< 0.1%
16.88	1	< 0.1%
16.51	1	< 0.1%
16.45	1	< 0.1%
16.38	1	< 0.1%
16.28	1	< 0.1%

payment_type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.2 MiB

Card	100326
Mobile Money	79661
Cash	20013

Length

Max length	12
Median length	4
Mean length	7.18644
Min length	4

Characters and Unicode

Total characters	1437288
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Card
2nd row	Card
3rd row	Card
4th row	Mobile Money
5th row	Card

Common Values

Value	Count	Frequency (%)
Card	100326	50.2%
Mobile Money	79661	39.8%
Cash	20013	10.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
card	100326	35.9%
mobile	79661	28.5%
money	79661	28.5%
cash	20013	7.2%

Most occurring characters

Value	Count	Frequency (%)
M	159322	11.1%
o	159322	11.1%
e	159322	11.1%
a	120339	8.4%
C	120339	8.4%
d	100326	7.0%
r	100326	7.0%
b	79661	5.5%
i	79661	5.5%
l	79661	5.5%
Other values (5)	279009	19.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1437288	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
M	159322	11.1%
o	159322	11.1%
e	159322	11.1%
a	120339	8.4%
C	120339	8.4%
d	100326	7.0%
r	100326	7.0%
b	79661	5.5%
i	79661	5.5%
l	79661	5.5%
Other values (5)	279009	19.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1437288	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
M	159322	11.1%
o	159322	11.1%
e	159322	11.1%
a	120339	8.4%
C	120339	8.4%
d	100326	7.0%
r	100326	7.0%
b	79661	5.5%
i	79661	5.5%
l	79661	5.5%
Other values (5)	279009	19.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1437288	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
M	159322	11.1%
o	159322	11.1%
e	159322	11.1%
a	120339	8.4%
C	120339	8.4%
d	100326	7.0%
r	100326	7.0%
b	79661	5.5%
i	79661	5.5%
l	79661	5.5%
Other values (5)	279009	19.4%

pickup_time
Date

Distinct	199156
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Memory size	10.7 MiB

Minimum	2024-04-27 00:07:34+02:27
Maximum	2025-04-27 22:59:48+02:27
Invalid dates	133295
Invalid dates (%)	66.6%

Histogram with fixed size bins (bins=50)

dropoff_time
Date

Distinct	199152
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Memory size	10.7 MiB

Minimum	2024-04-27 00:32:31+02:27
Maximum	2025-04-27 23:18:51+02:27
Invalid dates	133295
Invalid dates (%)	66.6%

Histogram with fixed size bins (bins=50)

pickup_lat
Real number (ℝ)

High correlation

Distinct	199939
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.8496

Minimum	-1.7863602
Maximum	30.544251
Zeros	0
Zeros (%)	0.0%
Negative	66705
Negative (%)	33.4%
Memory size	1.5 MiB

Quantile statistics

Minimum	-1.7863602
5-th percentile	-1.4458597
Q1	-1.1726825
median	6.5255743
Q3	29.934766
95-th percentile	30.20387
Maximum	30.544251
Range	32.330611
Interquartile range (IQR)	31.107448

Descriptive statistics

Standard deviation	13.362151
Coefficient of variation (CV)	1.1276458
Kurtosis	-1.5200219
Mean	11.8496
Median Absolute Deviation (MAD)	7.8167464
Skewness	0.51362791
Sum	2369919.9
Variance	178.54708
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30.17032084	2	< 0.1%
30.02513751	2	< 0.1%
30.22747669	2	< 0.1%
29.94414941	2	< 0.1%
30.15494402	2	< 0.1%
6.4954843	2	< 0.1%
29.93779094	2	< 0.1%
-1.477307868	2	< 0.1%
30.06949062	2	< 0.1%
29.96275768	2	< 0.1%
Other values (199929)	199980	> 99.9%

Value	Count	Frequency (%)
-1.78636024	1	< 0.1%
-1.786138458	1	< 0.1%
-1.786052555	1	< 0.1%
-1.786010688	1	< 0.1%
-1.786002169	1	< 0.1%
-1.785993166	1	< 0.1%
-1.785925265	1	< 0.1%
-1.785861207	1	< 0.1%
-1.785713235	1	< 0.1%
-1.785696613	1	< 0.1%

Value	Count	Frequency (%)
30.54425122	1	< 0.1%
30.54420604	1	< 0.1%
30.54418911	1	< 0.1%
30.54409791	1	< 0.1%
30.54401692	1	< 0.1%
30.54396155	1	< 0.1%
30.54392746	1	< 0.1%
30.54391416	1	< 0.1%
30.5439123	1	< 0.1%
30.54386606	1	< 0.1%

pickup_lng
Real number (ℝ)

High correlation

Distinct	199909
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.924133

Minimum	2.8792238
Maximum	37.31709
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	2.8792238
5-th percentile	3.2192672
Q1	3.4965737
median	31.238814
Q3	36.703772
95-th percentile	36.976458
Maximum	37.31709
Range	34.437867
Interquartile range (IQR)	33.207198

Descriptive statistics

Standard deviation	14.577572
Coefficient of variation (CV)	0.60932499
Kurtosis	-1.4743753
Mean	23.924133
Median Absolute Deviation (MAD)	5.5736725
Skewness	-0.64862442
Sum	4784826.6
Variance	212.5056
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
36.74522558	2	< 0.1%
36.88837441	2	< 0.1%
31.10638458	2	< 0.1%
31.3167754	2	< 0.1%
31.20898939	2	< 0.1%
36.85996114	2	< 0.1%
31.16173275	2	< 0.1%
36.95091208	2	< 0.1%
31.41844576	2	< 0.1%
31.30703943	2	< 0.1%
Other values (199899)	199980	> 99.9%

Value	Count	Frequency (%)
2.879223832	1	< 0.1%
2.879417245	1	< 0.1%
2.879496497	1	< 0.1%
2.879615229	1	< 0.1%
2.879618582	1	< 0.1%
2.879640474	1	< 0.1%
2.879641904	1	< 0.1%
2.879654809	1	< 0.1%
2.879672369	1	< 0.1%
2.879694625	1	< 0.1%

Value	Count	Frequency (%)
37.3170904	1	< 0.1%
37.31705642	1	< 0.1%
37.31698774	1	< 0.1%
37.31680759	1	< 0.1%
37.31666286	1	< 0.1%
37.31663847	1	< 0.1%
37.31660638	1	< 0.1%
37.31658794	1	< 0.1%
37.31657914	1	< 0.1%
37.31655886	1	< 0.1%

dropoff_lat
Real number (ℝ)

High correlation

Distinct	199958
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.849589

Minimum	-1.8332202
Maximum	30.592457
Zeros	0
Zeros (%)	0.0%
Negative	66705
Negative (%)	33.4%
Memory size	1.5 MiB

Quantile statistics

Minimum	-1.8332202
5-th percentile	-1.4459386
Q1	-1.1728684
median	6.5252348
Q3	29.935056
95-th percentile	30.204962
Maximum	30.592457
Range	32.425677
Interquartile range (IQR)	31.107925

Descriptive statistics

Standard deviation	13.362229
Coefficient of variation (CV)	1.1276534
Kurtosis	-1.5200087
Mean	11.849589
Median Absolute Deviation (MAD)	7.8165264
Skewness	0.51362487
Sum	2369917.7
Variance	178.54916
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30.11968501	2	< 0.1%
30.11683024	2	< 0.1%
29.87001763	2	< 0.1%
30.13205881	2	< 0.1%
30.2763164	2	< 0.1%
-1.24799864	2	< 0.1%
29.98393667	2	< 0.1%
29.92737718	2	< 0.1%
30.06795785	2	< 0.1%
6.71840666	2	< 0.1%
Other values (199948)	199980	> 99.9%

Value	Count	Frequency (%)
-1.833220233	1	< 0.1%
-1.831403474	1	< 0.1%
-1.827552947	1	< 0.1%
-1.826719269	1	< 0.1%
-1.825446853	1	< 0.1%
-1.825320517	1	< 0.1%
-1.824689248	1	< 0.1%
-1.824483484	1	< 0.1%
-1.824437397	1	< 0.1%
-1.824145068	1	< 0.1%

Value	Count	Frequency (%)
30.59245708	1	< 0.1%
30.59029799	1	< 0.1%
30.590092	1	< 0.1%
30.58756101	1	< 0.1%
30.58710143	1	< 0.1%
30.5863991	1	< 0.1%
30.58573358	1	< 0.1%
30.58404979	1	< 0.1%
30.58236108	1	< 0.1%
30.58117402	1	< 0.1%

dropoff_lng
Real number (ℝ)

High correlation

Distinct	199927
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.924173

Minimum	2.8309785
Maximum	37.364817
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	2.8309785
5-th percentile	3.2190504
Q1	3.4971949
median	31.239118
Q3	36.704067
95-th percentile	36.976494
Maximum	37.364817
Range	34.533838
Interquartile range (IQR)	33.206872

Descriptive statistics

Standard deviation	14.577642
Coefficient of variation (CV)	0.60932689
Kurtosis	-1.4743639
Mean	23.924173
Median Absolute Deviation (MAD)	5.5741678
Skewness	-0.6486212
Sum	4784834.7
Variance	212.50765
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
31.28006589	2	< 0.1%
36.62873381	2	< 0.1%
3.29159534	2	< 0.1%
36.80034642	2	< 0.1%
31.20880007	2	< 0.1%
36.82506623	2	< 0.1%
36.92675393	2	< 0.1%
36.92982384	2	< 0.1%
31.30734986	2	< 0.1%
31.27091018	2	< 0.1%
Other values (199917)	199980	> 99.9%

Value	Count	Frequency (%)
2.830978523	1	< 0.1%
2.831206114	1	< 0.1%
2.835444204	1	< 0.1%
2.836644356	1	< 0.1%
2.838114722	1	< 0.1%
2.838348575	1	< 0.1%
2.838472018	1	< 0.1%
2.838615336	1	< 0.1%
2.839658974	1	< 0.1%
2.839869603	1	< 0.1%

Value	Count	Frequency (%)
37.3648167	1	< 0.1%
37.36304964	1	< 0.1%
37.36281314	1	< 0.1%
37.36063183	1	< 0.1%
37.35816552	1	< 0.1%
37.35758053	1	< 0.1%
37.35649716	1	< 0.1%
37.3557481	1	< 0.1%
37.35432949	1	< 0.1%
37.35371629	1	< 0.1%

weather
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.9 MiB

Sunny	120151
Rainy	39976
Cloudy	29874
Foggy	9999

Length

Max length	6
Median length	5
Mean length	5.14937
Min length	5

Characters and Unicode

Total characters	1029874
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Foggy
2nd row	Sunny
3rd row	Cloudy
4th row	Cloudy
5th row	Sunny

Common Values

Value	Count	Frequency (%)
Sunny	120151	60.1%
Rainy	39976	20.0%
Cloudy	29874	14.9%
Foggy	9999	5.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
sunny	120151	60.1%
rainy	39976	20.0%
cloudy	29874	14.9%
foggy	9999	5.0%

Most occurring characters

Value	Count	Frequency (%)
n	280278	27.2%
y	200000	19.4%
u	150025	14.6%
S	120151	11.7%
R	39976	3.9%
a	39976	3.9%
i	39976	3.9%
o	39873	3.9%
C	29874	2.9%
l	29874	2.9%
Other values (3)	59871	5.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1029874	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	280278	27.2%
y	200000	19.4%
u	150025	14.6%
S	120151	11.7%
R	39976	3.9%
a	39976	3.9%
i	39976	3.9%
o	39873	3.9%
C	29874	2.9%
l	29874	2.9%
Other values (3)	59871	5.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1029874	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	280278	27.2%
y	200000	19.4%
u	150025	14.6%
S	120151	11.7%
R	39976	3.9%
a	39976	3.9%
i	39976	3.9%
o	39873	3.9%
C	29874	2.9%
l	29874	2.9%
Other values (3)	59871	5.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1029874	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	280278	27.2%
y	200000	19.4%
u	150025	14.6%
S	120151	11.7%
R	39976	3.9%
a	39976	3.9%
i	39976	3.9%
o	39873	3.9%
C	29874	2.9%
l	29874	2.9%
Other values (3)	59871	5.8%

city
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.0 MiB

Cairo	67436
Nairobi	66705
Lagos	65859

Length

Max length	7
Median length	5
Mean length	5.66705
Min length	5

Characters and Unicode

Total characters	1133410
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Nairobi
2nd row	Lagos
3rd row	Nairobi
4th row	Cairo
5th row	Nairobi

Common Values

Value	Count	Frequency (%)
Cairo	67436	33.7%
Nairobi	66705	33.4%
Lagos	65859	32.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
cairo	67436	33.7%
nairobi	66705	33.4%
lagos	65859	32.9%

Most occurring characters

Value	Count	Frequency (%)
i	200846	17.7%
a	200000	17.6%
o	200000	17.6%
r	134141	11.8%
C	67436	5.9%
N	66705	5.9%
b	66705	5.9%
L	65859	5.8%
g	65859	5.8%
s	65859	5.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1133410	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	200846	17.7%
a	200000	17.6%
o	200000	17.6%
r	134141	11.8%
C	67436	5.9%
N	66705	5.9%
b	66705	5.9%
L	65859	5.8%
g	65859	5.8%
s	65859	5.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1133410	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	200846	17.7%
a	200000	17.6%
o	200000	17.6%
r	134141	11.8%
C	67436	5.9%
N	66705	5.9%
b	66705	5.9%
L	65859	5.8%
g	65859	5.8%
s	65859	5.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1133410	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	200846	17.7%
a	200000	17.6%
o	200000	17.6%
r	134141	11.8%
C	67436	5.9%
N	66705	5.9%
b	66705	5.9%
L	65859	5.8%
g	65859	5.8%
s	65859	5.8%

loyalty_status
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.0 MiB

Bronze	121252
Silver	48332
Gold	21044
Platinum	9372

Length

Max length	8
Median length	6
Mean length	5.88328
Min length	4

Characters and Unicode

Total characters	1176656
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Bronze
2nd row	Gold
3rd row	Bronze
4th row	Bronze
5th row	Gold

Common Values

Value	Count	Frequency (%)
Bronze	121252	60.6%
Silver	48332	24.2%
Gold	21044	10.5%
Platinum	9372	4.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
bronze	121252	60.6%
silver	48332	24.2%
gold	21044	10.5%
platinum	9372	4.7%

Most occurring characters

Value	Count	Frequency (%)
r	169584	14.4%
e	169584	14.4%
o	142296	12.1%
n	130624	11.1%
B	121252	10.3%
z	121252	10.3%
l	78748	6.7%
i	57704	4.9%
S	48332	4.1%
v	48332	4.1%
Other values (7)	88948	7.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1176656	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	169584	14.4%
e	169584	14.4%
o	142296	12.1%
n	130624	11.1%
B	121252	10.3%
z	121252	10.3%
l	78748	6.7%
i	57704	4.9%
S	48332	4.1%
v	48332	4.1%
Other values (7)	88948	7.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1176656	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	169584	14.4%
e	169584	14.4%
o	142296	12.1%
n	130624	11.1%
B	121252	10.3%
z	121252	10.3%
l	78748	6.7%
i	57704	4.9%
S	48332	4.1%
v	48332	4.1%
Other values (7)	88948	7.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1176656	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	169584	14.4%
e	169584	14.4%
o	142296	12.1%
n	130624	11.1%
B	121252	10.3%
z	121252	10.3%
l	78748	6.7%
i	57704	4.9%
S	48332	4.1%
v	48332	4.1%
Other values (7)	88948	7.6%

	city	dropoff_lat	dropoff_lng	fare	loyalty_status	payment_type	pickup_lat	pickup_lng	surge_multiplier	tip	weather
city	1.000	1.000	1.000	0.004	0.019	0.000	1.000	1.000	0.016	0.006	0.000
dropoff_lat	1.000	1.000	-0.445	0.003	0.019	0.000	0.998	-0.445	0.005	-0.002	0.000
dropoff_lng	1.000	-0.445	1.000	-0.012	0.019	0.000	-0.445	0.998	-0.025	0.008	0.000
fare	0.004	0.003	-0.012	1.000	0.000	0.003	0.003	-0.012	0.453	0.032	0.164
loyalty_status	0.019	0.019	0.019	0.000	1.000	0.000	0.019	0.019	0.000	0.050	0.000
payment_type	0.000	0.000	0.000	0.003	0.000	1.000	0.000	0.000	0.000	0.001	0.000
pickup_lat	1.000	0.998	-0.445	0.003	0.019	0.000	1.000	-0.445	0.005	-0.002	0.000
pickup_lng	1.000	-0.445	0.998	-0.012	0.019	0.000	-0.445	1.000	-0.025	0.008	0.000
surge_multiplier	0.016	0.005	-0.025	0.453	0.000	0.000	0.005	-0.025	1.000	0.002	0.316
tip	0.006	-0.002	0.008	0.032	0.050	0.001	-0.002	0.008	0.002	1.000	0.001
weather	0.000	0.000	0.000	0.164	0.000	0.000	0.000	0.000	0.316	0.001	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	trip_id	user_id	driver_id	fare	surge_multiplier	tip	payment_type	pickup_time	dropoff_time	pickup_lat	pickup_lng	dropoff_lat	dropoff_lng	weather	city	loyalty_status
0	T000000	R05207	D00315	12.11	1.0	0.00	Card	2024-11-27 18:41:50+02:27	2024-11-27 19:33:50+02:27	-1.108123	36.912209	-1.068155	36.875377	Foggy	Nairobi	Bronze
1	T000001	R09453	D03717	8.73	1.0	0.02	Card	2024-10-28 23:13:48+00:14	2024-10-28 23:26:48+00:14	6.675266	3.515740	6.641734	3.525620	Sunny	Lagos	Gold
2	T000002	R00567	D02035	19.68	1.0	0.00	Card	2025-02-17 05:36:41+02:27	2025-02-17 05:52:41+02:27	-1.248589	37.010668	-1.273182	37.018586	Cloudy	Nairobi	Bronze
3	T000003	R09573	D02657	16.43	1.0	0.01	Mobile Money	2024-06-18 19:27:14+02:05	2024-06-18 19:32:14+02:05	29.819554	31.188780	29.837689	31.232978	Cloudy	Cairo	Bronze
4	T000004	R03446	D01026	8.70	1.0	1.06	Card	2024-10-05 09:58:16+02:27	2024-10-05 10:28:16+02:27	-1.676479	36.729219	-1.638395	36.694063	Sunny	Nairobi	Gold
5	T000005	R05852	D04849	16.98	1.4	0.52	Mobile Money	2024-07-02 18:20:12+02:27	2024-07-02 18:52:12+02:27	-1.370880	37.041389	-1.410399	37.045473	Rainy	Nairobi	Silver
6	T000006	R05611	D04686	17.49	1.4	0.00	Card	2024-10-19 07:17:45+02:05	2024-10-19 07:49:45+02:05	29.908624	31.099617	29.886305	31.127414	Rainy	Cairo	Silver
7	T000007	R04890	D02006	25.62	1.7	0.00	Mobile Money	2024-12-06 17:23:11+02:27	2024-12-06 18:06:11+02:27	-1.153775	36.358126	-1.134236	36.392381	Rainy	Nairobi	Gold
8	T000008	R04341	D03835	14.97	1.0	0.00	Card	2024-09-15 20:25:57+00:14	2024-09-15 20:30:57+00:14	6.695755	3.409177	6.679148	3.396333	Sunny	Lagos	Silver
9	T000009	R09904	D03494	12.15	1.3	0.11	Mobile Money	2025-03-19 08:53:00+02:05	2025-03-19 09:03:00+02:05	29.846699	31.279564	29.852363	31.260849	Sunny	Cairo	Silver

	trip_id	user_id	driver_id	fare	surge_multiplier	tip	payment_type	pickup_time	dropoff_time	pickup_lat	pickup_lng	dropoff_lat	dropoff_lng	weather	city	loyalty_status
199990	T199990	R00705	D03122	8.59	1.0	0.00	Card	2024-11-13 17:17:57+02:05	2024-11-13 18:10:57+02:05	30.237674	31.206882	30.265869	31.169655	Sunny	Cairo	Bronze
199991	T199991	R00810	D03011	19.65	1.0	3.26	Cash	2024-06-13 23:14:54+02:27	2024-06-13 23:23:54+02:27	-1.234208	36.757649	-1.259120	36.768658	Sunny	Nairobi	Bronze
199992	T199992	R02796	D02559	17.47	1.0	2.46	Cash	2025-01-04 06:16:29+02:27	2025-01-04 06:44:29+02:27	-1.238916	36.686793	-1.280580	36.734024	Sunny	Nairobi	Bronze
199993	T199993	R09831	D02825	18.14	1.0	0.80	Mobile Money	2025-04-06 10:03:22+00:14	2025-04-06 10:18:22+00:14	6.440663	3.533893	6.468872	3.566908	Sunny	Lagos	Silver
199994	T199994	R09903	D01628	8.19	1.0	0.26	Card	2024-05-29 18:44:26+02:27	2024-05-29 19:31:26+02:27	-1.208844	36.876605	-1.192507	36.877234	Sunny	Nairobi	Bronze
199995	T199995	R08022	D04562	26.79	1.3	0.00	Card	2025-03-14 18:16:26+00:14	2025-03-14 18:27:26+00:14	6.511389	3.297189	6.545565	3.327685	Cloudy	Lagos	Silver
199996	T199996	R05421	D03984	14.65	1.0	0.00	Card	2024-07-02 06:59:36+00:14	2024-07-02 07:36:36+00:14	6.489143	3.492786	6.453581	3.514289	Sunny	Lagos	Bronze
199997	T199997	R06619	D01173	12.87	1.2	0.00	Mobile Money	2024-05-06 20:38:57+00:14	2024-05-06 21:25:57+00:14	6.459348	3.527623	6.451930	3.521616	Rainy	Lagos	Bronze
199998	T199998	R02867	D00974	17.18	1.3	0.00	Mobile Money	2024-09-25 03:11:33+00:14	2024-09-25 03:45:33+00:14	6.540074	3.471683	6.540339	3.426481	Rainy	Lagos	Gold
199999	T199999	R07749	D04894	13.47	1.0	0.00	Card	2024-05-24 18:19:39+02:05	2024-05-24 18:51:39+02:05	30.234277	30.884004	30.279227	30.874865	Sunny	Cairo	Bronze

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script